﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/MasterPage.master" AutoEventWireup="true" CodeFile="WorkTime_OverTime2RestList.aspx.cs" Inherits="WorkTimeN_WorkTime_OverTime2RestList" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Titile" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Content" Runat="Server">
 <div>
        <InfoLight:WebDataSource ID="Master" runat="server" AutoApply="True" 
            WebDataSetID="WMaster" DataMember="ViewWorkTime_OverTime2Rest">
        </InfoLight:WebDataSource>
        <infolight:webnavigator id="WebNavigator1" runat="server" bindingobject="wgvMaster"
        oncommand="WebNavigator1_Command" showdatastyle="GridStyle" width="100%"
        statusstrip="WebStatusStrip1" cssclass="NavigatorBar" ctlheight="25" 
            height="25px">
        <navcontrols>
                <InfoLight:ControlItem ControlName="First" ControlText="掸" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/first_C.gif" MouseOverImageUrl="../image/uipics/first2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/first3_C.gif" />
                <InfoLight:ControlItem ControlName="Previous" ControlText="掸" ControlType="Image"
                    ControlVisible="True" ImageUrl="../image/uipics/previous_C.gif" MouseOverImageUrl="../image/uipics/previous2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/previous3_C.gif" />
                <InfoLight:ControlItem ControlName="Next" ControlText="掸" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/next_C.gif" MouseOverImageUrl="../image/uipics/next2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/next3_C.gif" />
                <InfoLight:ControlItem ControlName="Last" ControlText="ソ掸" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/last_C.gif" MouseOverImageUrl="../image/uipics/last2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/next3_C.gif" />
                <InfoLight:ControlItem ControlName="Add" ControlText="穝糤" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/add_C.gif" MouseOverImageUrl="../image/uipics/add2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/add3_C.gif" />
                <InfoLight:ControlItem ControlName="Update" ControlText="э" ControlType="Image"
                    ControlVisible="False" ImageUrl="../image/uipics/edit_C.gif" MouseOverImageUrl="../image/uipics/edit2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/edit3_C.gif" />
                <InfoLight:ControlItem ControlName="Delete" ControlText="埃" ControlType="Image"
                    ControlVisible="True" ImageUrl="../image/uipics/delete_C.gif" MouseOverImageUrl="../image/uipics/delete2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/delete3_C.gif" />
                <InfoLight:ControlItem ControlName="OK" ControlText="絋粄" ControlType="Image" ControlVisible="False"
                    ImageUrl="../image/uipics/ok_C.gif" MouseOverImageUrl="../image/uipics/ok2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/ok3_C.gif" />
                <InfoLight:ControlItem ControlName="Cancel" ControlText="" ControlType="Image"
                    ControlVisible="True" ImageUrl="../image/uipics/cancel_C.gif" MouseOverImageUrl="../image/uipics/cancel2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/cancel3_C.gif" />
                <InfoLight:ControlItem ControlName="Apply" ControlText="郎" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/apply_C.gif" MouseOverImageUrl="../image/uipics/apply2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/apply3_C.gif" />
                <InfoLight:ControlItem ControlName="Abort" ControlText="斌" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/abort_C.gif" MouseOverImageUrl="../image/uipics/abort2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/abort3_C.gif" />
                <InfoLight:ControlItem ControlName="Query" ControlText="琩高" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/query_C.gif" MouseOverImageUrl="../image/uipics/query2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/query3_C.gif" />
                <InfoLight:ControlItem ControlName="Print" ControlText="ゴ" ControlType="Image" ControlVisible="False"
                    ImageUrl="../image/uipics/print_C.gif" MouseOverImageUrl="../image/uipics/print2_C.gif"
                    Size="48" DisenableImageUrl="../image/uipics/print3_C.gif" />
                <InfoLight:ControlItem ControlName="Export" ControlType="Image" ControlVisible="False"
                    DisenableImageUrl="../Image/UIPics/Export3_C.gif" ImageUrl="../Image/UIPics/Export_C.gif"
                    MouseOverImageUrl="../Image/UIPics/Export2_C.gif" Size="48" />
            </navcontrols>
        <navstates>
                <InfoLight:WebNavigatorStateItem StateText="Initial" />
                <InfoLight:WebNavigatorStateItem StateText="Browsed" />
                <InfoLight:WebNavigatorStateItem StateText="Inserting" />
                <InfoLight:WebNavigatorStateItem StateText="Editing" />
                <InfoLight:WebNavigatorStateItem StateText="Applying" />
                <InfoLight:WebNavigatorStateItem StateText="Changing" />
                <InfoLight:WebNavigatorStateItem StateText="Querying" />
                <InfoLight:WebNavigatorStateItem StateText="Printing" />
            </navstates>
    </infolight:webnavigator>
    
    </div>
        <InfoLight:webgridview id="wgvMaster" runat="server"
            cellpadding="5" datasourceid="Master" forecolor="#333333" width="100%" 
        AbortIconUrl="../Image/UIPics/Abort.gif" AddIconUrl="../Image/UIPics/Add.gif" 
        ApplyIconUrl="../Image/UIPics/Apply.gif" 
        CancelIconUrl="../Image/UIPics/Cancel.gif" 
        MouseOverAbortIconUrl="../Image/UIPics/Abort2.gif" 
        MouseOverAddIconUrl="../Image/UIPics/Add2.gif" 
        MouseOverApplyIconUrl="../Image/UIPics/Apply2.gif" 
        MouseOverCancelIconUrl="../Image/UIPics/Cancel2.gif" 
        MouseOverOKIconUrl="../Image/UIPics/OK2.gif" 
        MouseOverQueryIconUrl="../Image/UIPics/Query2.gif" 
        OKIconUrl="../Image/UIPics/OK.gif" QueryIconUrl="../Image/UIPics/Query.gif" 
        HeaderStyleWrap="False" BackColor="White" BorderColor="White" 
        BorderStyle="Groove" BorderWidth="2px" PageSize="15">
            <PagerSettings Mode="NumericFirstLast" />
<FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True"></FooterStyle>
            <navcontrols>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/add2.gif" ControlText="add" ControlName="Add" ControlType="Image" ImageUrl="../image/uipics/add.gif"></InfoLight:ControlItem>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/ok2.gif" ControlText="Insert" ControlName="OK" ControlType="Image" ImageUrl="../image/uipics/ok.gif"></InfoLight:ControlItem>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/cancel2.gif" ControlText="cancel" ControlName="Cancel" ControlType="Image" ImageUrl="../image/uipics/cancel.gif"></InfoLight:ControlItem>
</navcontrols>
            <Columns>
<asp:TemplateField ShowHeader="False"><EditItemTemplate>
<asp:ImageButton id="ImageButton1" runat="server" Text="Update" CausesValidation="True" ImageUrl="~/Image/UIPics/OK.gif" CommandName="Update" __designer:wfdid="w3"></asp:ImageButton>&nbsp;<asp:ImageButton id="ImageButton2" runat="server" Text="Cancel" CausesValidation="False" ImageUrl="~/Image/UIPics/Cancel.gif" CommandName="Cancel" __designer:wfdid="w4"></asp:ImageButton>
</EditItemTemplate>
    <headerstyle wrap="False" />
<ItemTemplate>
<asp:ImageButton id="ImageButton3" runat="server" Text="Edit" CausesValidation="False" ImageUrl="~/Image/UIPics/Edit.gif" CommandName="Edit" __designer:wfdid="w1"></asp:ImageButton>&nbsp;<asp:ImageButton id="ImageButton4" runat="server" Text="Delete" CausesValidation="False" ImageUrl="~/Image/UIPics/Delete.gif" CommandName="Delete" __designer:wfdid="w2"></asp:ImageButton>
</ItemTemplate>
</asp:TemplateField>
                <asp:BoundField DataField="Id" HeaderText="编号" SortExpression="Id" 
                    ReadOnly="True" />
                <asp:TemplateField HeaderText="员工" SortExpression="EmployeeId">
                    <EditItemTemplate>
                        <InfoLight:WebRefVal ID="refEmp" runat="server" AllowAddData="False" 
                            BindingText="" BindingValue='<%# Bind("EmployeeId") %>' 
                            ButtonImageUrl="../Image/refval/RefVal.gif" DataBindingField="EmployeeId" 
                            DataSourceID="wdsEmp" DataTextField="empname" DataValueField="employeeid" 
                            MultiLanguage="False" PostBackButonClick="False" ReadOnly="False" 
                            ResxDataSet="" ResxFilePath="" UpdatePanelID="" UseButtonImage="True" 
                            ValueChangedJs="">
                        </InfoLight:WebRefVal>
                    </EditItemTemplate>
                    <FooterTemplate>
                        <InfoLight:WebRefVal ID="refEmp" runat="server" AllowAddData="False" 
                            BindingText="" BindingValue='<%# Bind("EmployeeId") %>' 
                            ButtonImageUrl="../Image/refval/RefVal.gif" DataBindingField="EmployeeId" 
                            DataSourceID="wdsEmp" DataTextField="empname" DataValueField="employeeid" 
                            MultiLanguage="False" PostBackButonClick="False" ReadOnly="False" 
                            ResxDataSet="" ResxFilePath="" UpdatePanelID="" UseButtonImage="True" 
                            ValueChangedJs="">
                        </InfoLight:WebRefVal>
                    </FooterTemplate>
                    <ItemTemplate>
                        <InfoLight:WebRefVal ID="refEmp" runat="server" AllowAddData="False" 
                            BindingText="" BindingValue='<%# Bind("EmployeeId") %>' BorderStyle="None" 
                            ButtonImageUrl="../Image/refval/RefVal.gif" DataBindingField="EmployeeId" 
                            DataSourceID="wdsEmp" DataTextField="empname" DataValueField="employeeid" 
                            MultiLanguage="False" PostBackButonClick="False" ReadOnly="True" ResxDataSet="" 
                            ResxFilePath="" UpdatePanelID="" UseButtonImage="True" ValueChangedJs="">
                        </InfoLight:WebRefVal>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="日期" SortExpression="OverTimeDate">
                    <EditItemTemplate>
                        <asp:TextBox ID="OverDate" runat="server" CssClass="Wdate" 
                            onfocus="WdatePicker({dateFmt:'yyyy-MM-dd',isShowClear:false,readOnly:true})" 
                            Text='<%# Bind("OverTimeDate") %>' Width="140px" />
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:TextBox ID="OverDate" runat="server" CssClass="Wdate" 
                            onfocus="WdatePicker({dateFmt:'yyyy-MM-dd',isShowClear:false,readOnly:true})" 
                            Text='<%# Bind("OverTimeDate") %>' Width="140px" />
                    </FooterTemplate>
                    <ItemTemplate>
                        <asp:Label ID="lViewWorkTime_OverTime2RestOverTimeDate" runat="server" 
                            Text='<%# Bind("OverTimeDate") %>' ToolTip="OverTimeDate"></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
            
                <asp:BoundField DataField="ORTimes" HeaderText="小时数" 
                    SortExpression="ORTimes" />
               
<asp:TemplateField HeaderText="类型" SortExpression="DataType">
    <EditItemTemplate>
        <InfoLight:WebDropDownList ID="wddlDateType" runat="server" 
            AutoInsertEmptyData="False" DataSourceID="wdsDataType" DataTextField="SDTName" 
            DataValueField="SDTId" DriverObject="" Filter="" FilterObject="" 
            onlyshowselecttext="False" SelectedValue='<%# Bind("DataType") %>'>
        </InfoLight:WebDropDownList>
    </EditItemTemplate>
    <FooterTemplate>
        <InfoLight:WebDropDownList ID="wddlDateType" runat="server" 
            AutoInsertEmptyData="False" DataSourceID="wdsDataType" DataTextField="SDTName" 
            DataValueField="SDTId" DriverObject="" Filter="" FilterObject="" 
            onlyshowselecttext="False" SelectedValue='<%# Bind("DataType") %>'>
        </InfoLight:WebDropDownList>
    </FooterTemplate>
<ItemTemplate>
                        <InfoLight:WebDropDownList ID="wddlDateType" runat="server" 
                            AutoInsertEmptyData="False" DriverObject="" Filter="" FilterObject="" 
                            onlyshowselecttext="True" SelectedValue='<%# Bind("DataType") %>' 
                            DataSourceID="wdsDataType" DataTextField="SDTName" DataValueField="SDTId">
                        </InfoLight:WebDropDownList>
                    
</ItemTemplate>
</asp:TemplateField>
                <asp:BoundField DataField="SheetId" HeaderText="单号" SortExpression="SheetId" />
                <asp:BoundField DataField="Remark" HeaderText="备注" SortExpression="Remark" />
</Columns>

<RowStyle BackColor="#EFF3FB"></RowStyle>

<EditRowStyle BackColor="#2461BF"></EditRowStyle>

<SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" Font-Bold="True"></SelectedRowStyle>

<PagerStyle BackColor="LightBlue" ForeColor="White" HorizontalAlign="Center"></PagerStyle>

            <addnewrowcontrols>
                <InfoLight:AddNewRowControlItem ControlID="refEmp" ControlType="RefVal" 
                    FieldName="EmployeeId" />
                <InfoLight:AddNewRowControlItem ControlID="OverDate" ControlType="TextBox" 
                    FieldName="OverTimeDate" />
                <InfoLight:AddNewRowControlItem ControlID="wddlDateType" 
                    ControlType="DropDownList" FieldName="DataType" />
            </addnewrowcontrols>

<HeaderStyle BackColor="DeepSkyBlue" ForeColor="White" Font-Bold="True"></HeaderStyle>

<AlternatingRowStyle BackColor="White" BorderColor="White"></AlternatingRowStyle>
</InfoLight:webgridview>
    <infolight:webdatasource id="wdsEmp" runat="server" selectalias="Usasdb" selectcommand="select employeeid,empname,department.departmentname from employees inner join department on (employees.departmentId=department.departmentId) ">
    </infolight:webdatasource>
    <infolight:webdatasource id="wdsDataType" runat="server" selectalias="Usasdb" 
        
        selectcommand="select WorkTime_SheetDataType.SDTId,WorkTime_SheetDataType.SDTName from WorkTime_SheetDataType where SDTId=2 or SDTId=1">
    </infolight:webdatasource>
    <Infolight:WebDefault ID="wdViewWorkTime_OverTime2Rest" runat="server" DefaultActive="True" DataSourceID="Master" DataMember="ViewWorkTime_OverTime2Rest" CarryOnActive="False" >
        <Fields>
            <InfoLight:DefaultFieldItem DefaultValue="0" FieldName="Id"></InfoLight:DefaultFieldItem>
        </Fields>
</Infolight:WebDefault>
<Infolight:WebValidate ID="wvViewWorkTime_OverTime2Rest" runat="server" 
        DataSourceID="Master" DataMember="ViewWorkTime_OverTime2Rest" RowCss="" 
        AltRowCss="" ForeColor="Red" >
    <Fields>
        <InfoLight:ValidateFieldItem CheckNull="True" FieldName="EmployeeId"></InfoLight:ValidateFieldItem>
        <InfoLight:ValidateFieldItem CheckNull="True" FieldName="OverTimeDate"></InfoLight:ValidateFieldItem>
        <InfoLight:ValidateFieldItem CheckNull="True" FieldName="ORTimes"></InfoLight:ValidateFieldItem>
        <InfoLight:ValidateFieldItem CheckNull="True" FieldName="DataType"></InfoLight:ValidateFieldItem>
    </Fields>
</Infolight:WebValidate>
</asp:Content>

